165

165

A Little Bit of Computer

Science

Listed below are the simple concepts that have been used in the programs described

in this book.

This list is not meant to be a complete list of features available in Excel VBA

Activate

A statement to make an object active. For example,

Workbooks(CurrentWorkbookName).Activate makes the

worksheet that is stored in CurrentWorbookName variable

Active.

ActiveChart

The chart that is currently active

ActivePresentation

The presentation object in powerpoint that is currently active (being

shown on the screen)

Add Operation

Add two operands

AddCallout

A statement used in VBA to add a callout box to a presentation

Application.Statusbar

The area at the bottom of a screen

Array

A set of variables that can be called by an index. This provides the

unique opportunity to maintain a sequence in which a collection

of variables is stored or used. For example, instead of using A, B,

C, D,… as variable names you could use ALPHA(1), ALPHA(2),

ALPHA(3), ALPHA(4)…

BeginArrowheadStyle

The style of the arrow head of a line at its top

BODMAS

A rule that is followed to control the order of calculation in an

expression

B =​ Bracket (parentheses)

O =​ Of (Exponent)

Button

User interface item available on the form

Call statement

A statement that calls a set of other statements that are organized to

do a specific set of tasks.

Parameters can be passed to these tasks through variables.

When parameters are passed there are two ways that the statements

in the “Call” block use them

By value, meaning it adopts the value passed during the call and

does not retain the value after the call is complete

By reference, which means it adopts the last assigned value to this

variable and retains the value if it is changed in the “Call” block

after the call is complete